UDF | Entry Point | Library Name | Input params | Returns | Description |
|---|---|---|---|---|---|
IB_UDF_abs |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_acos |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
addDay |
fbudf |
TIMESTAMP |
TIMESTAMP BY REFERENCE |
  |
|
addHour |
fbudf |
TIMESTAMP |
TIMESTAMP BY REFERENCE |
  |
|
addMilliSecond |
fbudf |
TIMESTAMP |
TIMESTAMP BY REFERENCE |
  |
|
addMinute |
fbudf |
TIMESTAMP |
TIMESTAMP BY REFERENCE |
  |
|
addMonth |
fbudf |
TIMESTAMP |
TIMESTAMP BY REFERENCE |
  |
|
addSecond |
fbudf |
TIMESTAMP |
TIMESTAMP BY REFERENCE |
  |
|
addWeek |
fbudf |
TIMESTAMP |
TIMESTAMP BY REFERENCE |
  |
|
addYear |
fbudf |
TIMESTAMP |
TIMESTAMP BY REFERENCE |
  |
|
IB_UDF_ascii_char |
ib_udf |
CSTRING (1) |
CSTRING (1) BY REFERENCE (FREE_IT) |
  |
|
IB_UDF_ascii_val |
ib_udf |
INTEGER |
INTEGER BY VALUE |
  |
|
IB_UDF_asin |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_atan |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_atan2 |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_bin_and |
ib_udf |
INTEGER |
INTEGER BY VALUE |
  |
|
IB_UDF_bin_or |
ib_udf |
INTEGER |
INTEGER BY VALUE |
  |
|
IB_UDF_bin_xor |
ib_udf |
INTEGER |
INTEGER BY VALUE |
  |
|
IB_UDF_ceiling |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_cos |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_cosh |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_cot |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_div |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
dNullIf |
fbudf |
DOUBLE PRECISION |
DOUBLE PRECISION BY REFERENCE |
  |
|
idNvl |
fbudf |
DOUBLE PRECISION |
DOUBLE PRECISION BY REFERENCE |
  |
|
DOW |
fbudf |
VARCHAR (15) |
VARCHAR (15) BY REFERENCE |
  |
|
power |
fbudf |
DOUBLE PRECISION |
DOUBLE PRECISION BY REFERENCE |
  |
|
IB_UDF_floor |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
getExactTimestamp |
fbudf |
TIMESTAMP |
TIMESTAMP BY REFERENCE |
  |
|
iNullIf |
fbudf |
NUMERIC (18, 4) |
NUMERIC (18, 4) BY REFERENCE |
  |
|
idNvl |
fbudf |
NUMERIC (18, 0) |
NUMERIC (18, 0) BY REFERENCE |
  |
|
fbround |
fbudf |
NUMERIC (18, 4) |
NUMERIC (18, 4) BY REFERENCE |
  |
|
fbtruncate |
fbudf |
NUMERIC (18, 0) |
NUMERIC (18, 0) BY REFERENCE |
  |
|
iNullIf |
fbudf |
INTEGER |
INTEGER BY REFERENCE |
  |
|
idNvl |
fbudf |
INTEGER |
INTEGER BY REFERENCE |
  |
|
IB_UDF_ln |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_log |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_log10 |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_lower |
ib_udf |
CSTRING (255) |
CSTRING (255) BY REFERENCE (FREE_IT) |
  |
|
IB_UDF_lpad |
ib_udf |
CSTRING (255) |
CSTRING (255) BY REFERENCE (FREE_IT) |
  |
|
IB_UDF_ltrim |
ib_udf |
CSTRING (255) |
CSTRING (255) BY REFERENCE (FREE_IT) |
  |
|
IB_UDF_mod |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_pi |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_rand |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
fbround |
fbudf |
INTEGER |
INTEGER BY REFERENCE |
  |
|
IB_UDF_rpad |
ib_udf |
CSTRING (255) |
CSTRING (255) BY REFERENCE (FREE_IT) |
  |
|
IB_UDF_rtrim |
ib_udf |
CSTRING (255) |
CSTRING (255) BY REFERENCE (FREE_IT) |
  |
|
SDOW |
fbudf |
VARCHAR (5) |
VARCHAR (5) BY REFERENCE |
  |
|
IB_UDF_sign |
ib_udf |
INTEGER |
INTEGER BY VALUE |
  |
|
IB_UDF_sin |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_sinh |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
sNullIf |
fbudf |
VARCHAR (100) |
VARCHAR (100) BY REFERENCE |
  |
|
sNvl |
fbudf |
VARCHAR (100) |
VARCHAR (100) BY REFERENCE |
  |
|
IB_UDF_sqrt |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
right |
fbudf |
VARCHAR (100) |
VARCHAR (100) BY REFERENCE |
  |
|
string2blob |
fbudf |
BLOB |
BLOB BY REFERENCE |
  |
|
IB_UDF_strlen |
ib_udf |
INTEGER |
INTEGER BY VALUE |
  |
|
IB_UDF_substr |
ib_udf |
CSTRING (255) |
CSTRING (255) BY REFERENCE (FREE_IT) |
  |
|
IB_UDF_substrlen |
ib_udf |
CSTRING (255) |
CSTRING (255) BY REFERENCE (FREE_IT) |
  |
|
IB_UDF_tan |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
IB_UDF_tanh |
ib_udf |
DOUBLE PRECISION |
DOUBLE PRECISION BY VALUE |
  |
|
fbtruncate |
fbudf |
INTEGER |
INTEGER BY REFERENCE |
  |
| This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m. |
|